Updated at 2025-06-26 20:01:38.751025
Conversion successful!
Created: C:/Users/Chris/Python/format_csv.py
Before update data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
CSV is already up to date.
After update (unchanged) data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
=== CALLING bitcoin_analysis_package ===
Before update data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
CSV is already up to date.
After update (unchanged) data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
time open high low close daily_return_percent day year year_return_percent cycle_year cycle_year_return_percent quarter quarter_return_percent month monthly_return_percent week weekly_return_percent half_month half_monthly_return_percent
5027 2025-06-25 106047.40625 108168.398438 105881.390625 107361.257812 1.238929 Wednesday 2025 15.013078 Year1 15.013078 2 30.076521 June 2.603241 26 6.311457 2H_June 1.710628
✅ Complete Bitcoin analysis completed successfully!
=== FINISHED bitcoin_analysis_package ===
time open high low close daily_return_percent day year year_return_percent cycle_year cycle_year_return_percent quarter quarter_return_percent month monthly_return_percent week weekly_return_percent half_month half_monthly_return_percent
5027 2025-06-25 106047.40625 108168.398438 105881.390625 107361.257812 1.238929 Wednesday 2025 15.013078 Year1 15.013078 2 30.076521 June 2.603241 26 6.311457 2H_June 1.710628
Output folder: C:\Users\Chris\Downloads\btc_report\btc_report_2025-06-26.1 Success! PDF saved to: C:\Users\Chris\Downloads\btc_report\btc_report_2025-06-26.1\btc_report_2025-06-26.pdf
1-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | 1 | October | 16.71% | 14.6% | 72.94% | -31.96% | 61.22% | 425 | False | 10.93% | 12.75% | 75% | 124 | 49.98% | 48.73% | 100% | 93 | -4.05% | -4.46% | 33.33% | 93 | 12.82% | 28.54% | 80.87% | 115 |
| 1 | 2 | February | 11.48% | 11.63% | 71.21% | -31.49% | 65.17% | 396 | False | 10.85% | 4.71% | 50% | 116 | 26.93% | 30.1% | 75% | 112 | -5.89% | 1.63% | 66.67% | 84 | 9.11% | 11.06% | 100% | 84 |
| 10 | 3 | November | 40.82% | 11.54% | 65.06% | -37.01% | 450.16% | 415 | False | 24.9% | 25.19% | 100% | 120 | 165.87% | 54.61% | 66.67% | 90 | -13.89% | -16.22% | 33.33% | 90 | 2.39% | 8.8% | 52.17% | 115 |
| 6 | 4 | July | 10.19% | 9.92% | 69.23% | -9.06% | 40.61% | 403 | False | 15.4% | 13.69% | 75% | 124 | 14.7% | 15.83% | 100% | 93 | 9.59% | 16.84% | 66.67% | 93 | -0.68% | -4.06% | 33.33% | 93 |
| 0 | 5 | January | 5.72% | 9.7% | 57.54% | -32.43% | 54.53% | 431 | False | 8.05% | 8.22% | 75% | 124 | 19.57% | 12% | 75% | 124 | -11.31% | -16.74% | 33.33% | 93 | 1.04% | -7.6% | 34.44% | 90 |
| 4 | 6 | May | 9.92% | 7.06% | 57.14% | -35.39% | 70.36% | 434 | False | 11.01% | 10.39% | 100% | 124 | 9.38% | 1.28% | 50% | 124 | 1.75% | -15.61% | 33.33% | 93 | 17.37% | -3.2% | 33.33% | 93 |
| 3 | 7 | April | 11.25% | 5.4% | 64.29% | -17.32% | 46.47% | 420 | False | 7.41% | 5.19% | 75% | 120 | 21.22% | 20.07% | 75% | 120 | 4.94% | -1.31% | 33.33% | 90 | 9.42% | 2.67% | 66.67% | 90 |
| 5 | 8 | June | 1.37% | 2.12% | 56.63% | -37.3% | 27.85% | 415 | True | 10.71% | 11.08% | 50% | 120 | -6.91% | -6.02% | 47.83% | 115 | -16.65% | -14.77% | 33.33% | 90 | 17.51% | 14.67% | 100% | 90 |
| 2 | 9 | March | 12.27% | -1.96% | 42.86% | -32.83% | 186.76% | 434 | False | -3.75% | -3.43% | 25% | 124 | 51.09% | 13.88% | 50% | 124 | -15.03% | -17.57% | 33.33% | 93 | 9.15% | 8.05% | 66.67% | 93 |
| 8 | 10 | September | -4.03% | -3.11% | 36.32% | -39.75% | 19.8% | 413 | False | 6.54% | 6.96% | 75% | 120 | -5.63% | -6.97% | 0% | 90 | -9.14% | -5.96% | 0% | 90 | -9.92% | 2.58% | 53.1% | 113 |
| 11 | 11 | December | 6.64% | -3.2% | 49.65% | -34.61% | 47.15% | 431 | False | 20.26% | 18.54% | 75% | 124 | -4.59% | -18.96% | 33.33% | 93 | -8.45% | -6.98% | 0% | 93 | 12.92% | 12% | 74.38% | 121 |
| 7 | 12 | August | 1.67% | -8.31% | 37.71% | -26.61% | 65.78% | 411 | False | -1.24% | -2.85% | 50% | 124 | 36.78% | 30.92% | 100% | 93 | -13.65% | -13.86% | 0% | 93 | -13% | -11.26% | 0% | 101 |
2-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 1 | November-December | 40.27% | 27.46% | 64.29% | -41.42% | 259.63% | 14 | False | 50.53% | 35.82% | 100% | 4 | 116.89% | 115.72% | 66.67% | 3 | -21.93% | -19.35% | 0% | 3 | 19.18% | 29.92% | 75% | 4 |
| 9 | 2 | October-November | 79.1% | 25.99% | 64.29% | -39.81% | 786.97% | 14 | False | 39.7% | 37.14% | 100% | 4 | 315.63% | 129.95% | 100% | 3 | -18.21% | -11.58% | 0% | 3 | 14.07% | 15.4% | 50% | 4 |
| 8 | 3 | September-October | 11.47% | 18.8% | 71.43% | -58.75% | 59.14% | 14 | False | 16.89% | 18.8% | 100% | 4 | 41.76% | 35.91% | 100% | 3 | -12.45% | -10.16% | 33.33% | 3 | 1.26% | 14.53% | 50% | 4 |
| 3 | 4 | April-May | 23.47% | 17.47% | 64.29% | -36.48% | 114.5% | 14 | False | 18.89% | 16.99% | 75% | 4 | 34.68% | 30.36% | 75% | 4 | 5.33% | 8.17% | 66.67% | 3 | 32.77% | -4.41% | 33.33% | 3 |
| 1 | 5 | February-March | 34.18% | 12.27% | 64.29% | -43.36% | 373.65% | 14 | False | 9.36% | 0.57% | 50% | 4 | 110.7% | 44.28% | 75% | 4 | -18.94% | -31.73% | 33.33% | 3 | 18.37% | 19.99% | 100% | 3 |
| 5 | 6 | June-July | 11.07% | 11.29% | 69.23% | -26.61% | 79.5% | 13 | True | 28.16% | 18.71% | 75% | 4 | 4.16% | 11.29% | 66.67% | 3 | -10.26% | -7.29% | 33.33% | 3 | 16.54% | 18.02% | 100% | 3 |
| 11 | 7 | December-January | 12.6% | 9.48% | 64.29% | -42.33% | 68.2% | 14 | False | 42.35% | 47.52% | 100% | 4 | -19.51% | -28.27% | 33.33% | 3 | -7.21% | -14.04% | 33.33% | 3 | 21.79% | 18.09% | 75% | 4 |
| 4 | 8 | May-June | 14.13% | 5.83% | 69.23% | -47.06% | 104.26% | 13 | False | 23% | 19.82% | 100% | 4 | 2.47% | -35.99% | 33.33% | 3 | -11.73% | -30.92% | 33.33% | 3 | 39.81% | 11.01% | 100% | 3 |
| 0 | 9 | January-February | 18.65% | 5.8% | 64.29% | -25.69% | 153.25% | 14 | False | 18.45% | 14.02% | 100% | 4 | 55.71% | 39.64% | 75% | 4 | -19.04% | -24.85% | 0% | 3 | 7.19% | 2.64% | 66.67% | 3 |
| 2 | 10 | March-April | 27.83% | 1.93% | 64.29% | -18.66% | 317.18% | 14 | False | 0.8% | 0.7% | 75% | 4 | 92.47% | 20.5% | 100% | 4 | -13.99% | -12.91% | 0% | 3 | 19.5% | 26.31% | 66.67% | 3 |
| 6 | 11 | July-August | 13.69% | 0.49% | 53.85% | -25.15% | 92.02% | 13 | False | 15.31% | 10.82% | 50% | 4 | 56.56% | 43.16% | 100% | 3 | -4.92% | 0.49% | 66.67% | 3 | -12.73% | -12.46% | 0% | 3 |
| 7 | 12 | August-September | 0.14% | -5.1% | 30.77% | -32.98% | 51.48% | 13 | False | 5.56% | -2.16% | 25% | 4 | 28.76% | 29.13% | 100% | 3 | -21.39% | -16.59% | 0% | 3 | -14.18% | -17.03% | 0% | 3 |
3-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 1 | November-January | 47.09% | 30.53% | 78.57% | -45.86% | 294.52% | 14 | False | 77.59% | 65.94% | 100% | 4 | 105% | 57.73% | 66.67% | 3 | -22.95% | -35.83% | 33.33% | 3 | 25.69% | 20.64% | 100% | 4 |
| 9 | 2 | October-December | 73.81% | 27.94% | 64.29% | -44.02% | 479.8% | 14 | False | 70.92% | 53.16% | 100% | 4 | 235.36% | 220.84% | 100% | 3 | -25.5% | -17.6% | 0% | 3 | 30.04% | 25.57% | 50% | 4 |
| 8 | 3 | September-November | 74.26% | 25.94% | 64.29% | -60.13% | 775.53% | 14 | False | 46.1% | 46.78% | 100% | 4 | 302.19% | 110.12% | 100% | 3 | -26.35% | -21.29% | 0% | 3 | 6.92% | 12.09% | 50% | 4 |
| 4 | 4 | May-July | 23.52% | 20.24% | 61.54% | -38.04% | 111.72% | 13 | False | 41.29% | 35.36% | 100% | 4 | 17.93% | -28.21% | 33.33% | 3 | -8.28% | -16.42% | 33.33% | 3 | 37.2% | 20.24% | 66.67% | 3 |
| 1 | 5 | February-April | 55.46% | 15% | 57.14% | -44.1% | 589.06% | 14 | False | 11.74% | 7.03% | 50% | 4 | 173.9% | 57.28% | 75% | 4 | -18.41% | -8.94% | 0% | 3 | 29.68% | 26.37% | 100% | 3 |
| 11 | 6 | December-February | 29.23% | 14.17% | 64.29% | -50.86% | 170.62% | 14 | False | 87.04% | 95.07% | 75% | 4 | -23.75% | -24.28% | 33.33% | 3 | -0.78% | -4.51% | 33.33% | 3 | 33.66% | 29.88% | 100% | 4 |
| 2 | 7 | March-May | 37.2% | 12.29% | 71.43% | -27.37% | 281.48% | 14 | False | 11.63% | 10.57% | 100% | 4 | 95.25% | 58.51% | 75% | 4 | -13.37% | -26.51% | 33.33% | 3 | 44.46% | 17.6% | 66.67% | 3 |
| 7 | 8 | August-October | 22.15% | 11.97% | 69.23% | -42.08% | 125.3% | 13 | False | 15.21% | 15.25% | 100% | 4 | 93.79% | 108.18% | 100% | 3 | -24.16% | -18.42% | 0% | 3 | 6.07% | 8.95% | 66.67% | 3 |
| 3 | 9 | April-June | 28.02% | 7.61% | 61.54% | -56.23% | 162.95% | 13 | False | 31.56% | 38.62% | 75% | 4 | 27.83% | -6.25% | 33.33% | 3 | -7.69% | -7.81% | 33.33% | 3 | 59.19% | 7.61% | 100% | 3 |
| 0 | 10 | January-March | 54.24% | 2.72% | 50% | -50.08% | 626.21% | 14 | False | 15.4% | 1.61% | 50% | 4 | 182.02% | 56.73% | 75% | 4 | -29.83% | -37.86% | 0% | 3 | 19.75% | 10.89% | 66.67% | 3 |
| 6 | 11 | July-September | 11.88% | 1% | 53.85% | -38.89% | 85.15% | 13 | False | 23.85% | 9.48% | 75% | 4 | 47.23% | 41.2% | 100% | 3 | -12.75% | -2.68% | 33.33% | 3 | -14.8% | -11.5% | 0% | 3 |
| 5 | 12 | June-August | 14.48% | 0.42% | 61.54% | -36.88% | 106.02% | 13 | True | 28.62% | 15.31% | 75% | 4 | 44.23% | 26.49% | 100% | 3 | -22.3% | -23.7% | 0% | 3 | 2.65% | 0.42% | 66.67% | 3 |
6-Month Period Performance:
| Rank | Period | Mean Return | Median Return | Success Rate | Min Return | Max Return | Count | Is Current | Year4 Mean | Year4 Median | Year4 Success | Year4 Count | Year1 Mean | Year1 Median | Year1 Success | Year1 Count | Year2 Mean | Year2 Median | Year2 Success | Year2 Count | Year3 Mean | Year3 Median | Year3 Success | Year3 Count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | 1 | September-February | 86.19% | 66.01% | 64.29% | -47.08% | 330.1% | 14 | False | 167.12% | 168.72% | 100% | 4 | 146.54% | 117.88% | 66.67% | 3 | -25.88% | -45.96% | 33.33% | 3 | 44.05% | 38.96% | 50% | 4 |
| 9 | 2 | October-March | 125.23% | 53.4% | 78.57% | -37.92% | 687.47% | 14 | False | 309.75% | 260.61% | 100% | 4 | 108.09% | 60.16% | 100% | 3 | -9.53% | -37.3% | 33.33% | 3 | 54.63% | 38.42% | 75% | 4 |
| 7 | 3 | August-January | 103.32% | 45.64% | 61.54% | -62.83% | 721.32% | 13 | False | 106.41% | 89.49% | 100% | 4 | 323.16% | 255.38% | 66.67% | 3 | -39.78% | -55.83% | 0% | 3 | 22.49% | 29.44% | 66.67% | 3 |
| 11 | 4 | December-May | 104.03% | 45.3% | 71.43% | -44.3% | 932.36% | 14 | False | 310.01% | 149.6% | 100% | 4 | -37.58% | -43.92% | 0% | 3 | 44.9% | 58.56% | 66.67% | 3 | 48.6% | 45.3% | 100% | 4 |
| 6 | 5 | July-December | 121.97% | 45.02% | 69.23% | -49.84% | 718.7% | 13 | False | 102.98% | 74.8% | 100% | 4 | 404.5% | 462.97% | 100% | 3 | -36.4% | -42.16% | 0% | 3 | 23.14% | 38.69% | 66.67% | 3 |
| 0 | 6 | January-June | 81.65% | 44.32% | 69.23% | -56.9% | 576.21% | 13 | False | 43.8% | 46.32% | 100% | 4 | 250.72% | 155.14% | 100% | 3 | -41.1% | -53.99% | 0% | 3 | 85.8% | 84.33% | 66.67% | 3 |
| 10 | 7 | November-April | 135.98% | 43.93% | 71.43% | -38.65% | 1171.64% | 14 | False | 404.54% | 206.19% | 100% | 4 | 41.84% | 43.64% | 66.67% | 3 | -1.29% | -16.42% | 33.33% | 3 | 40.98% | 47.41% | 75% | 4 |
| 5 | 8 | June-November | 111.69% | 42.85% | 69.23% | -47% | 776.49% | 13 | True | 82.81% | 75.72% | 100% | 4 | 387.4% | 332.88% | 100% | 3 | -44.3% | -45.97% | 0% | 3 | 30.5% | 38.57% | 66.67% | 3 |
| 4 | 9 | May-October | 54.16% | 31.17% | 76.92% | -45.54% | 377% | 13 | False | 63.52% | 57.77% | 100% | 4 | 142.9% | 45.52% | 100% | 3 | -34.02% | -31.81% | 0% | 3 | 41.12% | 31.17% | 100% | 3 |
| 1 | 10 | February-July | 75.2% | 30.4% | 76.92% | -39.4% | 384.14% | 13 | False | 52.64% | 59.83% | 100% | 4 | 201.9% | 196.25% | 100% | 3 | -30.26% | -27.52% | 0% | 3 | 84.07% | 30.4% | 100% | 3 |
| 2 | 11 | March-August | 62.14% | 12.04% | 61.54% | -53.59% | 297.45% | 13 | False | 41.85% | 33.7% | 75% | 4 | 194.46% | 281.75% | 100% | 3 | -32.92% | -31.97% | 0% | 3 | 51.93% | 12.04% | 66.67% | 3 |
| 3 | 12 | April-September | 44.76% | -3.17% | 46.15% | -57.33% | 303.8% | 13 | False | 63.26% | 57.17% | 75% | 4 | 103.52% | 32.2% | 66.67% | 3 | -25.36% | -14.01% | 0% | 3 | 31.44% | -3.17% | 33.33% | 3 |
Analysis includes data from 14 years: 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024 Historical Year-End Returns (Full Year): 2013 (Cycle Year 1): +5437.07% 2017 (Cycle Year 1): +1291.13% 2020 (Cycle Year 4): +303.87% 2012 (Cycle Year 4): +164.80% 2023 (Cycle Year 3): +154.34% 2016 (Cycle Year 4): +122.74% 2024 (Cycle Year 4): +111.33% 2019 (Cycle Year 3): +87.48% 2021 (Cycle Year 1): +57.18% 2015 (Cycle Year 3): +37.31% 2014 (Cycle Year 2): -57.44% 2011 (Cycle Year 3): -57.98% 2022 (Cycle Year 2): -65.41% 2018 (Cycle Year 2): -72.53% Average Year-End Return: +536.71% Median Year-End Return: +111.33% Returns by Cycle Year: Cycle Year 1 (years: 2013, 2017, 2021): Average: +2261.79% Sample size: 3 years Cycle Year 2 (years: 2014, 2022, 2018): Average: -65.12% Sample size: 3 years Cycle Year 3 (years: 2023, 2019, 2015, 2011): Average: +55.29% Sample size: 4 years Cycle Year 4 (years: 2020, 2012, 2016, 2024): Average: +175.69% Sample size: 4 years
Analysis includes 3 years matching cycle year(s) Year 1: 2013, 2017, 2021 Historical Year-End Returns (Full Year): 2013 (Cycle Year 1): +5437.07% 2017 (Cycle Year 1): +1291.13% 2021 (Cycle Year 1): +57.18% Average Year-End Return (Cycle Year 1): +2261.79% Median Year-End Return (Cycle Year 1): +1291.13% Returns by Cycle Year: Cycle Year 1 (years: 2013, 2017, 2021): Average: +2261.79% Sample size: 3 years
Calculating best fit line from start to end of data...
============================================================ BEST FIT LINE FROM START TO END SUMMARY: ============================================================ Total Data Period: 5028 days R-squared: 0.886864 Scale Type: Log Scale Daily Growth Rate: 0.1828% Annual Growth Rate: 94.77% Historical Performance: Start Price: $10.90 End Price: $107361.26 Total Change: $107350.36 (984865.67%) 1000-Day Projection: Projected Price: $1546837.38 Projected Change: $1439476.12 (1340.78%) Valuation Oscillator Summary: Current Deviation: -56.89% Max Overvaluation: 1065.33% Max Undervaluation: -92.28% 🟢 Currently UNDERVALUED relative to long-term trend
Finding top 3 best fitting linear regression channels for BTC (log scale)... Top 3 Best Fitting Linear Regression Channels (Log Scale): ================================================================================ 1. Window Size: 1000 days R-squared: 0.935873 Daily Growth Rate: 0.1946% Annual Growth Rate: 103.32% Price Change: $87936.26 (452.70%) Start Price: $19425.00 End Price: $107361.26 2. Window Size: 750 days R-squared: 0.880095 Daily Growth Rate: 0.1952% Annual Growth Rate: 103.73% Price Change: $81013.26 (307.47%) Start Price: $26348.00 End Price: $107361.26 3. Window Size: 90 days R-squared: 0.778500 Daily Growth Rate: 0.3613% Annual Growth Rate: 272.98% Price Change: $22982.26 (27.24%) Start Price: $84379.00 End Price: $107361.26 Plotting the top 3 regression channels with adaptive projections... (Windows ≤100 days: +30d projection, Windows >100 days: +180d projection)
Results stored in 'top_channels' variable
============================================================
SUMMARY - TOP 3 BEST FITTING CHANNELS:
============================================================
#1. 1000 days | R² = 0.935873
Annual Growth: 103.32%
Price Range: $19425 → $107361 (452.7%)
PRICE PROJECTIONS:
+30 days: $127,098 ($95,206 - $169,675)
+60 days: $134,732 ($100,918 - $179,876)
+90 days: $142,824 ($106,973 - $190,690)
#2. 750 days | R² = 0.880095
Annual Growth: 103.73%
Price Range: $26348 → $107361 (307.5%)
PRICE PROJECTIONS:
+30 days: $127,141 ($93,552 - $172,791)
+60 days: $134,799 ($99,176 - $183,219)
+90 days: $142,919 ($105,137 - $194,277)
#3. 90 days | R² = 0.778500
Annual Growth: 272.98%
Price Range: $84379 → $107361 (27.2%)
PRICE PROJECTIONS:
+30 days: $126,880 ($114,315 - $140,825)
+60 days: $141,377 ($126,856 - $157,561)
+90 days: $157,532 ($140,611 - $176,488)
========================================================================================================================
MONTE CARLO SIMULATION SUMMARY TABLE
========================================================================================================================
Method Median Risk/ 99% > 95% > 75% > Median 75% < 95% < 99% <
Name Change Reward Above Above Above Price Below Below Below
------------------------------------------------------------------------------------------------------------------------
Standard GBM (Normal) +22.9% 3.8:1 $50,003 $67,362 $100,428 $131,956 $174,405 $260,240 $345,021
Fat Tails (Student-t) +9.4% 2.2:1 $-9,819 $44,813 $85,793 $117,496 $157,449 $241,841 $350,328
Skewed Normal +27.0% 4.3:1 $59,362 $75,626 $106,700 $136,333 $172,789 $242,823 $306,491
Historical Bootstrap +24.0% 3.6:1 $49,216 $66,730 $102,037 $133,093 $172,523 $254,665 $340,660
Mixed (Bootstrap + Extremes) +20.7% 2.9:1 $16,915 $53,256 $95,553 $129,569 $172,524 $263,412 $361,054
------------------------------------------------------------------------------------------------------------------------
AVERAGE ACROSS METHODS +20.8% 3.4:1 $33,135 $61,558 $98,102 $129,689 $169,938 $252,596 $340,711
MEDIAN ACROSS METHODS +22.9% 3.6:1 $49,216 $66,730 $100,428 $131,956 $172,524 $254,665 $345,021
========================================================================================================================
🎯 CONSENSUS FORECAST (Average of All Methods):
• Expected Return (90 days): +20.8%
• Target Price: $129,689
• Risk/Reward Ratio: 3.4:1
• 95% Confidence Range: $61,558 to $252,596
• Extreme Downside (5% chance): Below $61,558 (-42.7%)
• Extreme Upside (5% chance): Above $252,596 (+135.3%)
• 📈 Probability of Profit: 68.0% chance of making money
• 📉 Probability of Loss: 32.0% chance of losing money
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (90 Days)
Method: Fat Tails (Student-t)
================================================================================
Median outcome: +9.4% change
Risk/Reward ratio: 2.2:1
→ 99% chance Bitcoin will be ABOVE $-9,819
→ 95% chance Bitcoin will be ABOVE $44,813
→ 75% chance Bitcoin will be ABOVE $85,793
→ Median value in 90 days $117,496
→ 75% chance Bitcoin will be BELOW $157,449
→ 95% chance Bitcoin will be BELOW $241,841
→ 99% chance Bitcoin will be BELOW $350,328
================================================================================
→ VaR (5%): $44,813 (-58.3%)
→ VaR (1%): $-9,819 (-109.1%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (90 Days)
Method: Mixed (Bootstrap + Extremes)
================================================================================
Median outcome: +20.7% change
Risk/Reward ratio: 2.9:1
→ 99% chance Bitcoin will be ABOVE $16,915
→ 95% chance Bitcoin will be ABOVE $53,256
→ 75% chance Bitcoin will be ABOVE $95,553
→ Median value in 90 days $129,569
→ 75% chance Bitcoin will be BELOW $172,524
→ 95% chance Bitcoin will be BELOW $263,412
→ 99% chance Bitcoin will be BELOW $361,054
================================================================================
→ VaR (5%): $53,256 (-50.4%)
→ VaR (1%): $16,915 (-84.2%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
========================================================================================================================
MONTE CARLO SIMULATION SUMMARY TABLE
========================================================================================================================
Method Median Risk/ 99% > 95% > 75% > Median 75% < 95% < 99% <
Name Change Reward Above Above Above Price Below Below Below
------------------------------------------------------------------------------------------------------------------------
Standard GBM (Normal) +54.1% 7.2:1 $42,184 $62,847 $112,044 $165,435 $243,705 $429,331 $648,170
Fat Tails (Student-t) +17.8% 3.1:1 $-89,518 $21,396 $77,303 $126,445 $197,752 $377,263 $618,740
Skewed Normal +66.4% 10.8:1 $56,020 $78,830 $127,334 $178,664 $252,209 $416,314 $595,843
Historical Bootstrap +57.9% 7.3:1 $41,833 $63,466 $112,711 $169,499 $247,093 $429,823 $660,539
Mixed (Bootstrap + Extremes) +48.7% 4.7:1 $-9,445 $37,229 $99,715 $159,693 $239,489 $433,948 $713,248
------------------------------------------------------------------------------------------------------------------------
AVERAGE ACROSS METHODS +49.0% 6.6:1 $ 8,215 $52,754 $105,821 $159,947 $236,049 $417,336 $647,308
MEDIAN ACROSS METHODS +54.1% 7.2:1 $41,833 $62,847 $112,044 $165,435 $243,705 $429,331 $648,170
========================================================================================================================
🎯 CONSENSUS FORECAST (Average of All Methods):
• Expected Return (90 days): +49.0%
• Target Price: $159,947
• Risk/Reward Ratio: 6.6:1
• 95% Confidence Range: $52,754 to $417,336
• Extreme Downside (5% chance): Below $52,754 (-50.9%)
• Extreme Upside (5% chance): Above $417,336 (+288.7%)
• 📈 Probability of Profit: 74.0% chance of making money
• 📉 Probability of Loss: 26.0% chance of losing money
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (188 Days)
Method: Fat Tails (Student-t)
================================================================================
Median outcome: +17.8% change
Risk/Reward ratio: 3.1:1
→ 99% chance Bitcoin will be ABOVE $-89,518
→ 95% chance Bitcoin will be ABOVE $21,396
→ 75% chance Bitcoin will be ABOVE $77,303
→ Median value in 188 days $126,445
→ 75% chance Bitcoin will be BELOW $197,752
→ 95% chance Bitcoin will be BELOW $377,263
→ 99% chance Bitcoin will be BELOW $618,740
================================================================================
→ VaR (5%): $21,396 (-80.1%)
→ VaR (1%): $-89,518 (-183.4%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
================================================================================
ENHANCED BITCOIN MONTE CARLO SUMMARY (188 Days)
Method: Mixed (Bootstrap + Extremes)
================================================================================
Median outcome: +48.7% change
Risk/Reward ratio: 4.7:1
→ 99% chance Bitcoin will be ABOVE $-9,445
→ 95% chance Bitcoin will be ABOVE $37,229
→ 75% chance Bitcoin will be ABOVE $99,715
→ Median value in 188 days $159,693
→ 75% chance Bitcoin will be BELOW $239,489
→ 95% chance Bitcoin will be BELOW $433,948
→ 99% chance Bitcoin will be BELOW $713,248
================================================================================
→ VaR (5%): $37,229 (-65.3%)
→ VaR (1%): $-9,445 (-108.8%)
📈 PRICE CHART WITH MONTE CARLO LEVELS:
--------------------------------------------------
🚀 RUNNING COMPLETE YTD ANALYSIS WITH AUTOMATIC CHART...
=== DATAFRAME PREPARATION ===
Date range: 2011-08-18 00:00:00 to 2025-06-25 00:00:00
Total data points: 5028
Price range: $2.24 to $111673.28
Using 2025 for YTD calculation
========================================================================================================================
ENHANCED DRIFT RATE COMPARISON - HISTORICAL vs YTD
========================================================================================================================
Method Hist Daily Hist Annual % YTD Daily YTD Annual % Difference %
------------------------------------------------------------------------------------------------------------------------
Simple Mean 0.003249 118.61% 0.001085 39.60% -79.00%
Geometric Mean 0.001831 94.96% 0.000844 30.81% -64.15%
Log Returns 0.001829 66.76% 0.001085 39.60% -27.16%
Volatility-Adjusted 0.002334 85.21% 0.000977 35.64% -49.56%
Rolling Window 0.002157 78.71% 0.001085 39.60% -39.11%
Regime-Aware 0.003249 118.61% 0.000844 30.81% -87.79%
SUMMARY STATISTICS:
--------------------------------------------------------------------------------
Metric Historical YTD Difference
--------------------------------------------------------------------------------
Average Annual % 93.81% 36.01% -57.80%
Median Annual % 90.09% 37.62% -52.46%
Std Dev % 19.43% 3.93% -15.49%
🎯 KEY INSIGHTS:
--------------------------------------------------
📉 YTD performance is UNDERPERFORMING historical median
• Historical median: 90.09% annually
• YTD compound annual: 30.81% annually
• Performance gap: -59.27%
📊 MONTE CARLO RECOMMENDATIONS:
--------------------------------------------------
• Conservative (lower): 0.308144 daily (11247.3% annual)
• Aggressive (higher): 0.900859 daily (32881.4% annual)
• Blended (70% hist, 30% YTD): 0.723045 daily (26391.1% annual)
• Historical median: 0.900859 daily (32881.4% annual)
• YTD-based: 0.308144 daily (11247.3% annual)
• Low historical variation allows using either mean or median
================================================================================
🎯 KEY YTD METRICS
================================================================================
📅 YTD Period: 2025-01-01 to 2025-06-25
⏱️ Days Elapsed: 175
📈 YTD Total Return: +13.74%
🎯 YTD Annual Drift: +30.81%
📊 Historical Median: +90.09%
🔄 Difference: -59.27% (UNDERPERFORMING)
📊 GENERATING PERFORMANCE CHART...
📊 CHART SUMMARY: • YTD Period: 2025-01-02 to 2025-06-25 • Current YTD Return: +13.7% • Expected at Benchmark Pace: +43.2% • Performance Gap: -29.4% • Status: UNDERPERFORMING benchmark 💾 SAVE THESE VALUES: ytd_annual_drift = 0.308144 historical_median = 0.900859 performance_gap = -59.27% 📈 Chart generated successfully! • Final YTD return: 13.7% • Final benchmark: 43.2% • Final gap: -29.4%
🎯 MARKET SIMILARITY ANALYSIS - NON-OVERLAPPING VERSION ============================================================ 📊 Calculating market features... 🎯 CURRENT FEATURES ANALYSIS: Days since ATH: 34 % from ATH: -4.12% RSI-14: 56.3 🔍 Finding similar periods... ✅ Found 6 diverse periods 📊 Analyzing top 3 most similar periods 🏆 TOP 3 SIMILAR PERIODS (NON-OVERLAPPING CHARTS) ================================================================================ #1 MATCH (Score: 0.998) - 28 features 📅 Period: 2024-09-05 00:00:00 to 2024-11-04 00:00:00 🔍 Current Signal Date: 2025-06-25 00:00:00 (Today's analysis date) 🔍 Key Comparisons: Days since ATH : Now 34.0 | Then 235.0 | Diff -201.0 % from ATH : Now -4.1 | Then -8.1 | Diff +4.0 30d return : Now 12.0 | Then 5.9 | Diff +6.1 RSI-14 : Now 56.3 | Then 51.3 | Diff +5.0 📈 What happened next: 5d : +13.1% 10d: +28.8% 20d: +44.5% 30d: +45.6% 60d: +44.7% 90d: +44.0%
└─ Non-overlapping chart created for Match #1 ──────────────────────────────────────────────────────────────────────────────── #2 MATCH (Score: 0.997) - 28 features 📅 Period: 2021-08-02 00:00:00 to 2021-10-01 00:00:00 🔍 Current Signal Date: 2025-06-25 00:00:00 (Today's analysis date) 🔍 Key Comparisons: Days since ATH : Now 34.0 | Then 170.0 | Diff -136.0 % from ATH : Now -4.1 | Then -25.8 | Diff +21.7 30d return : Now 12.0 | Then 16.9 | Diff -4.8 RSI-14 : Now 56.3 | Then 58.1 | Diff -1.7 📈 What happened next: 5d : +14.9% 10d: +19.3% 20d: +29.2% 30d: +27.4% 60d: +18.3% 90d: -2.1%
└─ Non-overlapping chart created for Match #2 ──────────────────────────────────────────────────────────────────────────────── #3 MATCH (Score: 0.997) - 28 features 📅 Period: 2024-05-28 00:00:00 to 2024-07-27 00:00:00 🔍 Current Signal Date: 2025-06-25 00:00:00 (Today's analysis date) 🔍 Key Comparisons: Days since ATH : Now 34.0 | Then 135.0 | Diff -101.0 % from ATH : Now -4.1 | Then -8.0 | Diff +3.9 30d return : Now 12.0 | Then -1.5 | Diff +13.6 RSI-14 : Now 56.3 | Then 63.2 | Diff -6.9 📈 What happened next: 5d : -3.8% 10d: -17.4% 20d: -13.3% 30d: -7.4% 60d: -7.0% 90d: -1.9%
└─ Non-overlapping chart created for Match #3
Applying clustering filter with 10-day window... Filtered from 183 to 17 periods Found 5 periods with correlation >= 0.7 Top correlated periods: 1. 2022-09-14 to 2023-03-08 (Year: 2022, Correlation: 0.8764) Extended to: 2023-09-04 (+180 days) 2. 2013-04-25 to 2013-10-17 (Year: 2013, Correlation: 0.8281) Extended to: 2014-04-15 (+180 days) 3. 2015-02-17 to 2015-08-11 (Year: 2015, Correlation: 0.8264) Extended to: 2016-02-07 (+180 days) 4. 2015-06-18 to 2015-12-10 (Year: 2015, Correlation: 0.8017) Extended to: 2016-06-07 (+180 days) 5. 2020-01-09 to 2020-07-02 (Year: 2020, Correlation: 0.7943) Extended to: 2020-12-29 (+180 days)
Detailed correlation results: start_date end_date correlation year period_length extended_length 0 2022-09-14 2023-03-08 0.876409 2022 176 356 1 2013-04-25 2013-10-17 0.828052 2013 176 356 2 2015-02-17 2015-08-11 0.826359 2015 176 356 3 2015-06-18 2015-12-10 0.801695 2015 176 356 4 2020-01-09 2020-07-02 0.794321 2020 176 356 Best match details: Period: 2022-09-14 to 2023-03-08 Correlation: 0.8764
=== CALLING bitcoin_analysis_package ===
Before update data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
CSV is already up to date.
After update (unchanged) data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
time open high low close daily_return_percent day year year_return_percent cycle_year cycle_year_return_percent quarter quarter_return_percent month monthly_return_percent week weekly_return_percent half_month half_monthly_return_percent
5027 2025-06-25 106047.40625 108168.398438 105881.390625 107361.257812 1.238929 Wednesday 2025 15.013078 Year1 15.013078 2 30.076521 June 2.603241 26 6.311457 2H_June 1.710628
✅ Complete Bitcoin analysis completed successfully!
=== FINISHED bitcoin_analysis_package ===
time open high low close daily_return_percent day year year_return_percent cycle_year cycle_year_return_percent quarter quarter_return_percent month monthly_return_percent week weekly_return_percent half_month half_monthly_return_percent
5027 2025-06-25 106047.40625 108168.398438 105881.390625 107361.257812 1.238929 Wednesday 2025 15.013078 Year1 15.013078 2 30.076521 June 2.603241 26 6.311457 2H_June 1.710628
ORIGINAL ROLLING RETURNS ANALYSIS:
================================================================================
================================================================================ AUTOMATIC FORWARD PERFORMANCE ANALYSIS: ================================================================================ Using 8 similar dates identified above for forward performance analysis FORWARD RETURNS ANALYSIS ================================================================================ Current 30-day return: -1.22% Similar periods threshold: ±0.50% Filters applied: Cycle Years: Year1, Quarters: 2 Total similar periods found: 8 ================================================================================ Forward Returns Summary: ------------------------------------------------------------------------------------------------------------------------ Window Count Median Mean Std Dev 95% CI Lower 95% CI Upper Min Max % Positive ------------------------------------------------------------------------------------------------------------------------ 7 days 8 1.27% 0.26% 2.92% -2.18% 2.70% -4.32% 4.58% 75.0% 14 days 7 -0.79% -0.03% 7.16% -6.65% 6.59% -10.23% 13.60% 28.6% 30 days 5 11.23% 9.53% 11.69% -4.99% 24.04% -4.33% 24.88% 80.0% 90 days 3 46.36% 49.89% 18.33% 4.35% 95.44% 33.58% 69.74% 100.0% 180 days 3 523.20% 397.08% 299.45% -346.79% 1140.95% 55.21% 612.84% 100.0% 365 days 3 152.85% 97.60% 101.08% -153.50% 348.69% -19.07% 159.00% 66.7% Top 5 Similar Periods (with 90-day forward returns): -------------------------------------------------------------------------------- Start Date End Date Forward Return Cycle Year Quarter 2021-06-04 2021-09-02 33.58% Year1 2 2017-06-30 2017-09-28 69.74% Year1 2 2017-06-21 2017-09-19 46.36% Year1 2 ================================================================================ Dates with sufficient 14-day forward data for chart: 7 Showing forward performance chart for these 7 periods: 1. 2017-06-21 2. 2017-06-30 3. 2021-06-04 4. 2025-04-03 5. 2025-04-11 6. 2025-06-01 7. 2025-06-03
ORIGINAL ROLLING RETURNS ANALYSIS: ================================================================================
================================================================================ AUTOMATIC FORWARD PERFORMANCE ANALYSIS: ================================================================================ Using 8 similar dates identified above for forward performance analysis FORWARD RETURNS ANALYSIS ================================================================================ Current 30-day return: -1.90% Similar periods threshold: ±0.50% Filters applied: Cycle Years: Year1, Quarters: 2 Total similar periods found: 8 ================================================================================ Forward Returns Summary: ------------------------------------------------------------------------------------------------------------------------ Window Count Median Mean Std Dev 95% CI Lower 95% CI Upper Min Max % Positive ------------------------------------------------------------------------------------------------------------------------ 7 days 8 0.35% 2.40% 7.79% -4.11% 8.91% -6.91% 15.43% 50.0% 14 days 7 -9.62% -5.14% 14.51% -18.56% 8.28% -19.26% 17.69% 28.6% 30 days 7 -28.07% -27.95% 7.73% -35.10% -20.81% -38.25% -17.46% 0.0% 90 days 7 -32.79% -32.28% 11.64% -43.05% -21.51% -45.44% -10.40% 0.0% 180 days 7 8.91% 88.12% 207.17% -103.48% 279.72% -8.11% 557.03% 85.7% 365 days 7 -26.77% 25.90% 144.61% -107.84% 159.65% -34.85% 353.62% 14.3% Top 5 Similar Periods (with 90-day forward returns): -------------------------------------------------------------------------------- Start Date End Date Forward Return Cycle Year Quarter 2021-05-01 2021-07-30 -26.99% Year1 2 2021-04-30 2021-07-29 -30.70% Year1 2 2021-04-24 2021-07-23 -32.79% Year1 2 2021-04-23 2021-07-22 -36.88% Year1 2 2021-04-20 2021-07-19 -45.44% Year1 2 ================================================================================ Dates with sufficient 30-day forward data for chart: 7 Showing forward performance chart for these 7 periods: 1. 2013-05-27 2. 2021-04-12 3. 2021-04-20 4. 2021-04-23 5. 2021-04-24 6. 2021-04-30 7. 2021-05-01
ORIGINAL ROLLING RETURNS ANALYSIS: ================================================================================
================================================================================ AUTOMATIC FORWARD PERFORMANCE ANALYSIS: ================================================================================ Using 2 similar dates identified above for forward performance analysis FORWARD RETURNS ANALYSIS ================================================================================ Current 30-day return: 23.09% Similar periods threshold: ±0.50% Filters applied: Cycle Years: Year1, Quarters: 2 Total similar periods found: 2 ================================================================================ Forward Returns Summary: ------------------------------------------------------------------------------------------------------------------------ Window Count Median Mean Std Dev 95% CI Lower 95% CI Upper Min Max % Positive ------------------------------------------------------------------------------------------------------------------------ 7 days 2 -1.56% -1.56% 2.39% -23.07% 19.95% -3.25% 0.13% 50.0% 14 days 2 0.34% 0.34% 0.62% -5.22% 5.90% -0.09% 0.78% 50.0% 30 days 1 -1.90% -1.90% nan% nan% nan% -1.90% -1.90% 0.0% 90 days 0 N/A N/A N/A N/A N/A N/A N/A N/A 180 days 0 N/A N/A N/A N/A N/A N/A N/A N/A 365 days 0 N/A N/A N/A N/A N/A N/A N/A N/A Top 5 Similar Periods (with 90-day forward returns): -------------------------------------------------------------------------------- Start Date End Date Forward Return Cycle Year Quarter ================================================================================ Dates with sufficient 90-day forward data for chart: 0 No dates have sufficient 90-day forward data for performance chart. Try reducing 'forward_days' parameter or check data availability.
===== Bitcoin 50% Recovery Points from 30%+ Drawdowns in 2024-2025 ===== Total recovery points found: 2 ----- Average Statistics ----- Average Drawdown: 32.4% Average Forward Returns: 7 days: -2.9% (Win rate: 50.0%) 14 days: 0.7% (Win rate: 50.0%) 30 days: 3.6% (Win rate: 50.0%) 60 days: 5.1% (Win rate: 100.0%) 90 days: 22.6% (Win rate: 100.0%) 180 days: 58.5% (Win rate: 100.0%)
===== Bitcoin 50% Recovery Points from 30%+ Drawdowns Cycle Year(s): Year1 ===== Total recovery points found: 14 Showing 3 out of 14 recovery points (sorted by drawdown size) Recovery Point #1 (sorted by drawdown size): Date: 2013-10-18 00:00:00 Year: 2013 | Cycle_year: Year1 | Quarter: 4 | Month: October Price at recovery: $152.89 Previous peak (high): $259.34 Drawdown low: $45.00 Drawdown amount: $214.34 (82.6%) Recovery amount: $107.89 (50.3%) Forward Returns: 7d: 22.0% | 14d: 32.2% | 30d: 212.2% | 60d: 341.5% | 90d: 444.1% | 180d: 660.2% Recovery Point #2 (sorted by drawdown size): Date: 2017-01-01 00:00:00 Year: 2017 | Cycle_year: Year1 | Quarter: 1 | Month: January Price at recovery: $997.75 Previous peak (high): $1163.00 Drawdown low: $382.21 Drawdown amount: $780.79 (67.1%) Recovery amount: $615.54 (78.8%) Forward Returns: 7d: -8.8% | 14d: -17.6% | 30d: -3.4% | 60d: 26.0% | 90d: 8.6% | 180d: 147.1% Recovery Point #3 (sorted by drawdown size): Date: 2021-08-13 00:00:00 Year: 2021 | Cycle_year: Year1 | Quarter: 3 | Month: August Price at recovery: $47860.58 Previous peak (high): $64895.22 Drawdown low: $28600.00 Drawdown amount: $36295.22 (55.9%) Recovery amount: $19260.58 (53.1%) Forward Returns: 7d: 3.1% | 14d: 2.6% | 30d: -3.8% | 60d: 17.0% | 90d: 35.4% | 180d: 101.6% ----- Average Statistics ----- Average Drawdown: 43.6% Average Forward Returns: 7 days: 13.0% (Win rate: 64.3%) 14 days: 25.3% (Win rate: 71.4%) 30 days: 57.4% (Win rate: 71.4%) 60 days: 85.9% (Win rate: 92.9%) 90 days: 135.9% (Win rate: 100.0%) 180 days: 364.6% (Win rate: 100.0%)
🎯 COMPLETE ANALYSIS FOR Year1
============================================================
🔄 Calculating days since 20-day highs/lows...
📊 CURRENT STATUS (20-DAY WINDOW):
Days since 20-day high: 16
Days since 20-day low: 3
20-day high: $110561.42
20-day low: $98286.20
Current close: $107361.26
Current cycle year: Year1
Current month: June
Current quarter: Q2
------------------------------------------------------------
🧪 HISTORICAL TESTING - 20-DAY WINDOW:
============================================================
🔴 Testing: Days since 20-day HIGH = 16
🔍 APPLYING FILTERS:
==================================================
📅 Cycle Year: Year1
📈 Records: 5,028 → 1,271 (25.3%)
==================================================
=== Historical Analysis: days_since_20d_high = 16 (Filtered: Year: Year1) ===
Total occurrences: 45
Date range: 2013-01-03 00:00:00 to 2025-06-25 00:00:00
Cycle Year breakdown: {'Year1': np.int64(45)}
Quarter breakdown: {1: np.int64(13), 2: np.int64(15), 3: np.int64(10), 4: np.int64(7)}
Month breakdown: {'June': np.int64(7), 'July': np.int64(6), 'March': np.int64(6), 'January': np.int64(5), 'December': np.int64(5), 'April': np.int64(4), 'September': np.int64(4), 'May': np.int64(4), 'November': np.int64(2), 'February': np.int64(2)}
--- 1-Day Forward Returns ---
Average return: -0.27%
Median return: -0.02%
Win rate: 47.7%
Best return: 8.33%
Worst return: -15.71%
Standard deviation: 4.00%
68% of returns fall between: -4.28% to 3.73%
--- 5-Day Forward Returns ---
Average return: 1.08%
Median return: 1.46%
Win rate: 59.1%
Best return: 18.94%
Worst return: -14.97%
Standard deviation: 7.38%
68% of returns fall between: -6.30% to 8.46%
--- 10-Day Forward Returns ---
Average return: 4.44%
Median return: 2.85%
Win rate: 65.9%
Best return: 41.79%
Worst return: -17.91%
Standard deviation: 12.44%
68% of returns fall between: -8.00% to 16.88%
--- 20-Day Forward Returns ---
Average return: 8.60%
Median return: 6.77%
Win rate: 59.5%
Best return: 63.12%
Worst return: -32.68%
Standard deviation: 21.99%
68% of returns fall between: -13.39% to 30.60%
🟢 Testing: Days since 20-day LOW = 3
🔍 APPLYING FILTERS:
==================================================
📅 Cycle Year: Year1
📈 Records: 5,028 → 1,271 (25.3%)
==================================================
=== Historical Analysis: days_since_20d_low = 3 (Filtered: Year: Year1) ===
Total occurrences: 39
Date range: 2013-04-15 00:00:00 to 2025-06-25 00:00:00
Cycle Year breakdown: {'Year1': np.int64(39)}
Quarter breakdown: {1: np.int64(14), 2: np.int64(12), 3: np.int64(6), 4: np.int64(7)}
Month breakdown: {'June': np.int64(7), 'March': np.int64(7), 'January': np.int64(6), 'December': np.int64(5), 'April': np.int64(4), 'July': np.int64(3), 'September': np.int64(3), 'October': np.int64(1), 'November': np.int64(1), 'May': np.int64(1), 'February': np.int64(1)}
--- 1-Day Forward Returns ---
Average return: 0.55%
Median return: 0.36%
Win rate: 55.3%
Best return: 26.92%
Worst return: -13.97%
Standard deviation: 7.07%
68% of returns fall between: -6.52% to 7.62%
--- 5-Day Forward Returns ---
Average return: 4.10%
Median return: 3.35%
Win rate: 68.4%
Best return: 71.01%
Worst return: -21.98%
Standard deviation: 15.09%
68% of returns fall between: -10.98% to 19.19%
--- 10-Day Forward Returns ---
Average return: 5.09%
Median return: 3.41%
Win rate: 60.5%
Best return: 91.76%
Worst return: -37.88%
Standard deviation: 19.32%
68% of returns fall between: -14.23% to 24.41%
--- 20-Day Forward Returns ---
Average return: 10.50%
Median return: 5.50%
Win rate: 62.2%
Best return: 60.09%
Worst return: -24.85%
Standard deviation: 23.15%
68% of returns fall between: -12.65% to 33.65%
📊 SUMMARY COMPARISON TABLE (20-DAY WINDOW - Year: Year1):
================================================================================
Signal Type Occurrences 1D Avg 5D Avg 10D Avg 20D Avg 1D Win% 5D Win% 10D Win% 20D Win%
---------------------------------------------------------------------------------------------------------------
Days Since 20D High = 16 45 -0.3% 1.1% 4.4% 8.6% 48% 59% 66% 60%
Days Since 20D Low = 3 39 0.6% 4.1% 5.1% 10.5% 55% 68% 61% 62%
================================================================================
⚡ QUICK INSIGHTS (20-DAY WINDOW - Year: Year1):
📈 20D High Signal (16d): 20-day avg 8.6% | Best: 63% | Worst: -33%
└─ 68% of returns fall between: -13.4% to +30.6% (±1 std dev)
📉 20D Low Signal (3d): 20-day avg 10.5% | Best: 60% | Worst: -25%
└─ 68% of returns fall between: -12.7% to +33.7% (±1 std dev)
================================================================================
📈 Creating original visualizations...
🔍 APPLYING FILTERS:
==================================================
📅 Cycle Year: Year1
📈 Records: 5,028 → 1,271 (25.3%)
==================================================
📈 CREATING INDIVIDUAL YEAR CHARTS FOR Year1: ============================================================ 🔴 High Signal Charts (20D High = 16 days): 📅 Creating individual charts for Year1: [np.int32(2013), np.int32(2017), np.int32(2021), np.int32(2025)]
🟢 Low Signal Charts (20D Low = 3 days): 📅 Creating individual charts for Year1: [np.int32(2013), np.int32(2017), np.int32(2021), np.int32(2025)]
Conversion successful!
Created: C:/Users/Chris/Python/format_csv.py
Before update data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
CSV is already up to date.
After update (unchanged) data summary:
Date range: 2011-08-18 to 2025-06-25
Number of rows: 5028
Bitcoin performance after first all time high in 30 days (Year1)
================================================================
Date Bitcoin Close High Price Cycle Year Week Month 3 Month 6 Month Year
01/21/2013 16.52 16.98 Year1 13.01 81.60 619.19 414.77 4893.28
02/20/2013 30.00 30.07 Year1 4.37 133.00 291.67 242.83 1772.87
03/25/2013 75.11 80.00 Year1 39.40 98.38 33.68 64.28 677.22
11/06/2013 263.24 265.00 Year1 49.48 207.71 205.04 64.49 32.95
02/23/2017 1,188.11 1,193.92 Year1 5.80 -19.53 103.71 243.82 755.65
04/30/2017 1,350.21 1,356.00 Year1 15.09 63.20 98.53 327.48 584.50
06/06/2017 2,880.74 2,933.00 Year1 -6.17 -9.73 48.47 290.52 165.85
08/05/2017 3,263.62 3,339.66 Year1 18.12 31.05 118.98 175.74 115.48
10/12/2017 5,445.00 5,445.00 Year1 4.66 16.71 173.46 25.54 13.59
11/16/2017 7,846.96 7,976.79 Year1 1.81 144.53 20.95 8.00 -29.80
12/16/2017 19,187.78 19,377.00 Year1 -23.81 -29.08 -56.96 -65.36 -83.36
01/01/2021 29,402.64 29,700.00 Year1 38.31 12.72 99.74 19.16 62.49
02/08/2021 46,416.45 46,712.12 Year1 3.29 20.33 25.61 -3.89 -5.01
03/13/2021 61,165.19 61,781.83 Year1 -4.95 -2.18 -38.95 -24.15 -38.22
04/13/2021 63,564.48 63,769.00 Year1 -11.11 -21.82 -47.92 -13.92 -35.27
10/20/2021 65,990.31 67,016.50 Year1 -11.40 -11.91 -35.78 -38.15 -71.14
01/20/2025 102,141.00 109,356.00 Year1 -0.05 -5.38 -16.59 5.11 5.11
05/21/2025 109,682.00 110,730.00 Year1 -1.71 -5.81 -2.12 -2.12 -2.12
Average 7.45 39.10 91.15 96.34 489.67
Median 3.83 14.71 41.08 22.35 23.27
% Positive 61.1 55.6 66.7 66.7 61.1
Found 155 total ATHs to analyze
Analyzing 14-day pause ATHs...
Found 14 ATHs with 14-day pause
Bitcoin Forward Returns FROM Pause End - 14 day pauses (Year1)
==============================================================
ATH Date ATH Days End Date End Price Decline Cycle 1W 1W DD 1W Max 2W 2W DD 2W Max 1M 1M DD 1M Max 2M 2M DD 2M Max 3M 3M DD 3M Max 6M 6M DD 6M Max 1Y 1Y DD 1Y Max
04/10/2013 162.00 14 04/24/2013 149.00 -8.02 Year1 -21.64 -29.60 14.28 -24.05 -45.30 14.28 -13.62 -45.30 14.28 -32.61 -45.30 14.28 -41.62 -57.72 14.28 20.89 -57.72 22.10 237.05 -57.72 680.54
11/30/2013 1,119.80 14 12/14/2013 854.99 -23.65 Year1 -30.18 -55.30 1.75 -16.37 -55.30 1.75 -3.74 -55.30 16.38 -23.66 -55.30 16.38 -26.27 -55.30 16.38 -33.44 -60.26 16.38 -58.30 -67.84 16.38
03/10/2017 1,116.97 14 03/24/2017 929.06 -16.82 Year1 15.20 -4.06 16.35 28.16 -4.06 29.38 33.68 -4.06 34.79 143.71 -4.06 144.87 192.07 -4.06 220.75 317.03 -4.06 436.01 819.96 -4.06 2016.76
06/12/2017 2,667.06 14 06/26/2017 2,421.22 -9.22 Year1 5.34 -5.38 7.18 -4.04 -6.58 9.01 4.29 -24.42 21.34 79.91 -24.42 85.03 51.34 -24.42 105.68 503.79 -24.42 712.24 150.62 -24.42 712.24
09/02/2017 4,599.90 14 09/16/2017 3,678.93 -20.02 Year1 2.72 -5.87 12.06 17.59 -5.87 18.21 56.18 -5.87 58.92 98.26 -5.87 114.41 374.91 -5.87 387.48 124.66 -5.87 434.56 76.68 -5.87 434.56
12/17/2017 18,953.00 14 12/31/2017 13,880.00 -26.77 Year1 16.17 -7.77 24.17 -1.67 -7.78 24.17 -28.16 -33.56 24.17 -21.45 -57.34 24.17 -50.08 -57.34 24.17 -55.30 -58.40 24.17 -73.39 -77.51 24.17
01/08/2021 40,667.07 14 01/22/2021 32,992.06 -18.87 Year1 3.81 -11.64 17.06 16.15 -11.64 17.45 74.26 -11.64 76.87 64.77 -11.64 87.26 56.66 -11.64 96.70 -2.59 -13.31 96.70 6.36 -13.31 109.14
02/21/2021 57,492.91 14 03/07/2021 50,967.30 -11.35 Year1 15.79 -3.24 21.22 12.59 -3.24 21.22 13.83 -3.24 21.22 10.75 -7.78 27.33 -30.28 -41.01 27.33 -1.85 -43.89 27.33 -25.41 -43.89 35.38
03/13/2021 61,165.19 14 03/27/2021 55,839.42 -8.71 Year1 2.19 -2.08 7.64 7.03 -2.08 9.64 -3.16 -15.82 16.22 -29.60 -46.16 16.22 -43.41 -48.78 16.22 -19.58 -48.78 16.22 -16.07 -48.78 23.57
04/14/2021 62,986.09 14 04/28/2021 54,901.97 -12.83 Year1 4.75 -4.59 7.46 -10.05 -11.61 8.56 -34.99 -45.24 8.56 -36.80 -47.91 8.56 -28.10 -47.91 8.56 14.93 -47.91 22.07 -27.59 -47.91 25.68
10/20/2021 65,990.31 14 11/03/2021 62,930.72 -4.64 Year1 3.16 -4.48 9.64 -4.06 -7.20 9.64 -14.60 -18.07 9.64 -24.76 -33.31 9.64 -38.45 -47.64 9.64 -38.79 -47.64 9.64 -67.89 -72.04 9.64
11/10/2021 64,921.43 14 11/24/2021 57,185.06 -11.92 Year1 0.12 -6.78 3.95 -11.61 -26.61 3.95 -11.09 -26.61 3.95 -36.53 -40.54 3.95 -33.08 -42.38 3.95 -49.14 -55.58 3.95 -70.99 -72.93 3.95
01/20/2025 102,141.00 14 02/03/2025 101,457.00 -0.67 Year1 -3.93 -6.63 0.32 -5.60 -7.26 0.32 -10.69 -22.93 0.32 -17.35 -24.50 0.32 -7.04 -26.63 0.32 5.82 -26.63 10.36 5.82 -26.63 10.36
05/22/2025 111,673.28 14 06/05/2025 101,575.95 -9.04 Year1 4.29 -0.40 8.85 3.06 -0.40 8.85 5.70 -3.24 8.85 5.70 -3.24 8.85 5.70 -3.24 8.85 5.70 -3.24 8.85 5.70 -3.24 8.85
Average -13.04 1.27 -10.56 10.85 0.51 -13.92 12.60 4.85 -22.52 22.54 12.88 -29.10 40.09 27.31 -33.85 67.17 56.58 -35.55 131.47 68.75 -40.44 293.66
Median -11.63 3.49 -5.62 9.25 -2.85 -7.23 9.64 -3.45 -20.50 16.30 -19.40 -28.91 16.30 -27.19 -41.70 16.30 1.93 -45.77 22.09 -5.19 -45.90 24.93
% Positive 78.6 0.0 100.0 42.9 0.0 100.0 42.9 0.0 100.0 42.9 0.0 100.0 35.7 0.0 100.0 50.0 0.0 100.0 50.0 0.0 100.0
Breakdown by Pause Period:
14-day pause: 14 ATHs
₿ Starting Bitcoin Report Deployment ================================================== 📊 Step 1: Converting notebook to HTML... Current directory: C:\Users\Chris\Python ✓ Success: jupyter nbconvert --to html --no-input btc_report.ipynb 📁 Step 2: Copying HTML file to repository... ✓ Copied btc_report.html as index.html to repository 🔄 Step 3: Git operations... Current directory: C:\Users\Chris\my-jupyter-notebooks ✓ Success: git pull origin main Output: Already up to date. ✓ Success: git status Output: On branch main Your branch is up to date with 'origin/main'. Changes not staged for commit: (use "git add <file>..." to update what will be committed) (use "git restore <file>..." to discard changes in working directory) modified: index.html no changes added to commit (use "git add" and/or "git commit -a") ✓ Success: git add . ✓ Success: git commit -m "Update index.html with latest Bitcoin report - 2025-06-26 20:05" Output: [main 02d661c] Update index.html with latest Bitcoin report - 2025-06-26 20:05 1 file changed, 1928 insertions(+), 2698 deletions(-) ✓ Success: git push origin main 🎉 Bitcoin Report deployment completed successfully! ₿ Your Bitcoin report is now live!
Finished 2025-06-26 20:05:41.747746